"""
 encoding    : utf-8
 @File       : get_data.py
 @Author     : sugar 
 @Version    :
 @Description:
 @Date       : 2024/06/15
"""
import xlrd


class Get_Login:
    '''获取登录数据 用户名以及密码'''

    def get_by_xls(self):
        mylist = []
        a = xlrd.open_workbook(r'E:\automatic_test_oa_system\data\oa_login_data.xls')
        b = a.sheet_by_index(0)
        mylist.append(b.row_values(1))
        return mylist


class Get_Url:
    '''获取测试网址'''

    def get_url(self):
        mylist = []
        a = xlrd.open_workbook(r'E:\automatic_test_oa_system\data\oa_login_data.xls')
        b = a.sheet_by_index(1)
        mylist.append(b.row_values(0))
        mylist.append(b.row_values(1))
        return mylist



